This first code example demonstrates how to create a connection to the Access version of the Northwind database and create a property named "Orders" to which the grid will be bound. The code should be placed in the App.xaml.cs file.
| C# |
Copy Code |
|---|---|
public partial class App : Application { public DataSet Data { get; set; } public DataTable Orders { get; set; } protected override void OnStartup( StartupEventArgs e ) { // Set the licence key Xceed.Wpf.DataGrid.Licenser.LicenseKey = "Enter your license key here"; Data = Xceed.Wpf.DataGrid.Samples.SampleData.DataProvider.GetNorthwindDataSet(); Orders = Data.Tables[ "Orders" ]; base.OnStartup( e ); } } | |
| VB.NET |
Copy Code |
|---|---|
Public Partial Class App Inherits Application Public Property Data As DataSet Public Property Orders As DataTable Protected Overrides Sub OnStartup(ByVal e As StartupEventArgs) ' Set the licence key Xceed.Wpf.DataGrid.Licenser.LicenseKey = "Enter your license key here" Data = Xceed.Wpf.DataGrid.Samples.SampleData.DataProvider.GetNorthwindDataSet() Orders = Data.Tables("Orders") MyBase.OnStartup(e) End Sub End Class | |
The next example demonstrates how to bind a grid to the Orders table, which is retrieved through the Orders property implemented in the code above.
| XAML |
Copy Code |
|---|---|
<Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid"> <Grid.Resources> <xcdg:DataGridCollectionViewSource x:Key="cvs_orders" Source="{Binding Source={x:Static Application.Current}, Path=Orders}"/> </Grid.Resources> <xcdg:DataGridControl x:Name="OrdersGrid" ItemsSource="{Binding Source={StaticResource cvs_orders}}"/> </Grid> | |
